Learning Objectives

After completing this lesson, you'll be able to:

• Create points using addresses.
• Understand the limitations of geocoding services.

Video

Resources

• CulturalSpaces2016.csv

Introduction

Sometimes your dataset will only contain addresses without latitude/longitude data. To handle these kinds of situations, you can use the Geocoder transformer.

The following services are supported:

Some Geocoder services support "reverse geocoding," finding the nearest address given a coordinate. Note also that the exact address formatting that will give you the best chance of successfully geocoding will vary by service. Refer to the service's documentation and use an AttributeManager or other transformers to ensure you are giving the transformer an address format it expects.

Exercise

1. Open FME Workbench 2022.0. Click Blank Workspace to start a new workspace. Click Readers > Add Reader and set Format to CSV (Comma-Separated Value).
2. Click the ellipsis button [...] and select the downloaded CulturalSpaces2016.csv dataset or paste in the URL.
3. Add a Geocoder to the canvas connected to the CSV feature type.
4. Sign up for a free Google Geocoder API and then paste the API key into the API Key parameter in the Geocoder parameters.
   1. If you don't want to sign up, you can use the free OpenStreetMap geocoder.
5. Next, for Street Address, identify where the address is stored and select that Attribute. For this example, the address is stored in ADDRESS.
6. Before running the translation, set the Rejected Feature Handling workspace parameter to Continue Translation. We need to do this because some of the cultural spaces don't have an address associated with them, so our translation will stop when the Geocoder rejects these features. To do this, in the Navigator Pane > Workspace Parameters > Translation > Rejected Feature Handling > Continue Translation. After running the translation, you will see the points in Visual Preview.
   
7. Run the workspace and inspect the results

Results

 The output of point features using any of the three methods. Stylized in FME Data Inspector using map tiles by Stamen Design, under CC-BY-3.0. Data by OpenStreetMap, under CC-BY-SA.